import pandas as pd
from mysql_utils import Mysql
filepath = 'D:/compete/服务外包创新创业/算法/数据/data_shop_2.xlsx'
df=pd.read_excel(filepath,
                 usecols=[0,1,3,4,10,11,12],
                 index_col=None,
                 header=0,
                 dtype={'DATA_MONTH':str,'USER_ID':str,'SHOP_SALES_VOLUME':int,'SHOP_SALES_AMOUNT':float})

print(type(df.loc[0]))
print(df.loc[0])

# a = []
# a.append(df.loc[1])
# a.append(df.loc[2])
# mysql = Mysql()
# mysql.shop_insert(a)
#
# mysql.close()